﻿CREATE TABLE [dbo].[AppAnalytics]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [AppId] INT NULL, 
    [StartDateTime] DATETIME NULL, 
    [Username] NVARCHAR(50) NULL, 
    [HostWebUrl] VARCHAR(256) NULL, 
    [AppPage] VARCHAR(256) NULL, 
    [Language] VARCHAR(5) NULL, 
    CONSTRAINT [FK_AppAnalytics_ToApp] FOREIGN KEY ([AppId]) REFERENCES [App]([AppId])
)
